MacWorld 1996 July

home *** CD-ROM | disk | FTP | other *** search

/ MacWorld 1996 July / Macworld (1996-07).dmg / System 7.5 Update 2.0 / FileMaker Pro 3.0 CD Extras / FileMaker Examples / Templates w⁄data / Business / Expenses System / Employee Expenses (.txt) next >

Wrap

FileMaker Pro Database | 1996-01-25 | 163KB | 1,105 lines

5SC+8PzEy83NJbXp70AqGUhy5n6a XBamEMmp3puYQaIgc+/czYaRm4JWk8BWSxDNvqvIkcw1k3qA4IKnDo0F62gnFAfjAqey8KQ4JJdA UJGADJ/8MdIv9WKfUm7oxatgZOi9PyjFVPXzrB2SAaZiwdst01JRye0tJfZ65rLKcljs4XnXPbK8 WalsXWk4z93Mw8fGf9ysbnDK7KrKhuE9kHGM1+cMxVsXgEFZCKXgBznIyltVQWzk6yZCs2qE3I3d 2GCHCl8TOiAkpMtwhyIWVk6fzkxiJ3i5TwospeUPHrlD9EhcmcnUL9JuWcFhf2W5RLKbxgJido8n WB55T4RoKCm+Qo9PRbXJyJkForiYrhKjdbwFysPnuQm50ilusWBWpefOqJYPRjR38LAXgmBm80ou fzhe3rmSLVdr8J/CmlX1SVivhhz+zIgGCaIYlaJxQx9modrsd/r0Aok4BjJC+A6YB9GMJjge4ItZ HBAM2016AUG95 Pro 3.0 UuUiJ4kmsb+GU3+doMrhPzZgI8+IBixF74huIp ubGKrzgVI1p3w5BZOpq8ROdeGeZuRpicJRz2ceeBqEp8ua5RZ8GtFjUIKsqyXZpxmx8MrrRj5r+T aKeRVydhvrCcNTZCLvK5Mj9znvQhI1OKIHTkHn7TwANDnpQEDmexy8eSAyLhfVazulXIbebsxiDH q41IDhDDi/SOYpNfI/8P43H0Ovn/qvx/eeU+9NmXUlI0Yrek1hZT8M6Cp+72/CYlNRaeVkzdR+Qg rrIRThhfLz4pw9FRjsty5atVklleJy+Cei5Khv6GqhgAJ+2aMWvmcPIvSYc5T1ZclvjdHcZtNNmV 49vzc3OTFinF4G48M6CXagks6m7v/NaESdwSiHcUyYZWlDsoIUvLCCqjxoZaH4QMmx0pBHJYU3zG tWKXSWFvkhWsMDY393NFAJ0RhsZ4ixMfqZcrQSVPgqX VT3GXK2ysH1SuwC6gixJF4yRYfANZzRfhOekLRanl dl2L/4/g8ch18v914n/VWNxeOHc1N0tHbWBBvyisucbBsFZbrK4tZpFPU0Sfi3Gq8cVwLYOP2Qjj WgsWLm5G5eIa4zsKyD72OTIVAI22Os5xmCyztSyOFhp5uUpRRRtETrwT8ZWgEiw02jnb2nCkrVW7 IFW0cy0OMJonqUSrGMYeIkA/Bs2WM9MgbqdPTtur9WQMFLhoL33coXklbDrzGL6oN6T1HkvGeUTW +fRV+KO7UUBkQLrgjQ+ojET+A2+9XqkcqHyH9/Uob69CfJR+psxsvtPoxg6nnrvIZrWqsxxN/CFg ebwynV7XxpxA2B01bcfG8STPIxvlcZQB5HParuGQOoqfzaNnlhu1bNKoRWfjrN6uLsd0Jy4wOE1P +lICmAvNMQNAuF2bNIg0E3rt5LeBrz7tCJlJXScqR/oZ4P+C1pAWULpf/Ad2ozTglFe5u+U6Tx88 aEZNNvdQeUqq5C4F+K7U2wvmPJyawSQseCWFgvmbvN/ly+2UYL1S7 HBAM3016AUG95@ le'unchE me'0D e'n0E le'unchE sh/pp/ng0F sh/pp/ng0 sys-t sys-tF consultantsE expoD office supplies joseD seminar shipping systemF joseD launchE lineE marketingE materialsE HP DeskJet 540 Printer Pro 2.0 - 2.1F! Pro 3.0 AMOUNT REIMB APPROVED BY CHECK NUMBER CREATED BY DATE 1 DATE 2 DATE 3 DATE 4 DATE 5 DATE 6 DATE 7 DATE APPROVED DATE CREATED DATE EMP SIGNED DATE MODIFIED DATE OF END OF WEEK DATE REIMBURSED EMPLOYEE ID EXPENSE REPORT ID FIRST NAME j FULL NAME GRAND TOTAL LAST LAYOUT g LAST NAME MILE 1 MILE 2 MILE 3 MILE 4 MILE 5 MILE 6 MILE 7 MILE DOLLARS 1 MILE DOLLARS 2 MILE DOLLARS 3 MILE DOLLARS 4 MILE DOLLARS 5 MILE DOLLARS 6 MILE DOLLARS 7 PROJECT PURPOSE OF TRIP RATE PER MILE SUBTOTAL 1 SUBTOTAL 2 SUBTOTAL 3 SUBTOTAL 4 SUBTOTAL 5 SUBTOTAL 6 SUBTOTAL 7 TOTAL MILE AMOUNT TOTAL MILES Franz App Sunday Monday Tuesday Wednesday Thursday Friday Saturday January February March April August September October November December 1st Quarter 2nd Quarter 3rd Quarter 4th Quarter 11/27/95 Form View - Expenses A List View Expense Report Information Report Menu Form View - Payment Form View - ExpensesB Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Expense Report IDB Date CreatedB Date ModifiedB Date 1B 3 - 6 Date 2B 3 - 5 Date 3B 3 - 4 Date 4B 3 - 3 Date 5B 3 - 2 Date of End of WeekB XoThe end of the week usually falls on a Saturday. Are you sure you want to use this date as the end of the week? 1995)) Date 6B 3 - 1 Employee IDB Subtotal 1B 5) + Subtotal 2B 6) + Subtotal 3B 7) + Subtotal 4B 8) + Subtotal 5B 9) + Subtotal 6B ;) + Subtotal 7B <) + Grand TotalB Q) + Rate per MileB Mile 1B Mile 2B Mile 3B Mile 4B Mile 5B Mile 6 Mile 7B Date 7B Mile Dollars 1B Mile Dollars 2B Mile Dollars 3B Mile Dollars 4B Mile Dollars 5B Mile Dollars 6B Mile Dollars 7B Total Mile AmountB ProjectB Purpose of TripB Created ByB Date ReimbursedB Amount ReimbB Date Emp SignedB Approved ByB Date ApprovedB InfoB Total MilesB Last LayoutB Check NumberB First NameB kA Last NameB lA Full NameB A List ViewB Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Your Own Button Your Own Button Record Delete Record Record Reports View As View As Close Totals Miles Purpose of Trip Project | Rate/Mile Week End Emp. ID Report ID Enter data for Employee Expenses Mile Dollars Employee Payment Expenses Employee Expenses Line Items File... Employees File... Total Expense ReportB Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Amount` Reimb.a Totalb Weeke Report IDf Your Own Buttong Your Own Buttonh Recordi Delete Recordj Recordk Reportsl View As Listm View As Formn Closeo Amount` Reimb.a Totalb Weeke Report IDf Your Own Buttong Your Own Buttonh Recordi Delete Recordj Recordk Reportsl View As Listm View As Formn Closeo p3Click to see more information for an Expense Report Emp. IDt Employee InformationB Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Your Own Button Reports View As View As Close Rev. 10/6/95 z<Please return completed form to accounts payable department. Manager Signature Employee Signature Date Reimbursed Amount Reimbursed Totals: Miles:tment. Manager Signature Employee Signature Date Reimbursed Amount Reimbursed Totals: Miles: Totals Dates: Rate/Mile Purpose of Trip Project Department Phone/Extension Emp. ID Week Ending Report ID Company Name and Logo Employee Expense Report Report MenuB Your Own ButtonI ReportsJ View As ListK View As FormL CloseM InfoO0Information about the Employee Expenses solutionP Info for this Solution ut the Employee Expenses solutionP Info for this Solution Your Own ReportB Your Own ReportC Your Own ReportD Expense ReportE Your Own ButtonF ReportsG View As ListH View As FormI CloseJ InfoK>Click on any of these buttons to preview the respective reportL Select a report ButtonF ReportsG View As ListH View As FormI CloseJ InfoK>Click on any of these buttons to preview the respective reportL Select a report Form View - PaymentB Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Your Own ButtonB ReportsC View As ListD View As FormE CloseF Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Your Own Button Your Own Button Record Delete Record Record Reports View As View As Close Amount Date Reimbursed Purpose of Trip Project Week End Emp. ID Report ID /Enter Payment information for Employee Expenses Employee Payment Expenses Employee Expenses Line Items File... Employees File... Total Approved By Date Signed Date Approved Check Number File... Total Approved By Date Signed Date Approved Check Number 05/09/95Y 10/6/95n 7/30/95o 7/31/95p 8/1/95q 8/2/95r 8/3/95s 8/5/95t 8/4/95} 8/5/95 Demo Files ]&Go to Office Supplies Expo in San Jose Paul Farrah 9/1/95 1414.55 8/7/95 8/7/95 13156 05/09/95Y 10/6/95n 10/1/95o 10/2/95p 10/3/95q 10/4/95r 10/5/95s 10/7/95t 10/6/95} 10/7/95 Plan Launch ]LWork with marketing consultants on materials for launch of new product line. Paul Farrah 10/6/95 05/09/95Y 10/6/95n 7/16/95o 7/17/95p 7/18/95q 7/19/95r 7/20/95s 7/22/95t 7/21/95} 7/22/95 Shipping System ]%Go to seminar on new shipping system. Paul Farrah 7/21/95 Your Own ButtonB ReportsC View As ListD View As FormE CloseF Open Employee Names File Open Expense Line Items File Information List View Report Menu Sort by Expense Report ID Sort by Last Name Sort by Date of End of Week Expense Report Open Script Sort by Expense Report ID Expense Report Sort by Last Name Sort by Date of End of Week Open Script )=400 Cancel You did not enter any find criteria; all records will be displayed.C) Cancel No records match this request.E) ist View Report Menu Yesfter Noarter Helvetica Geneva Times Times New Roman Arial MS Sans Serif wwwwww ffffff UUUUUU DDDDDD 3333B """""" wwxwwxw ggvgvv gvwxgwghg vhgvvww fvfgfwffv eVefefe VvffVefVVefUe\ ffFdeefeefddfDeVdfEdfFdffk EUeFFEUFEUFFUeTeVFeUUdVEEk UTdUTeETeETeEUFTUTUFTUUTeK TEETEETUETUETUDUDEETUDTUE[ 4CDD4E4ET D4DD4CDDC C3C3C34C4C3CC43C "#""3"129 #11#22122"3! wwwwww ffffff UUUUUU DDDDDD 3333B """""" #11#22122"3! "#""3"129 C3C3C34C4C3CC43C DDCD4DD4CDDC 4CDD4E4ET TEETEETUETUETUDUDEETUDTUE[ dUTeETeETeEUFTUTUFTUUTeK EUeFFEUFEUFFUeTeVFeUUdVEEk ffFdeefeefddfDeVdfEdfFdffk eVefefe VvffVefVVefUe\ fvfgfwffv ggvgvv gvwxgwghg vhgvvww Ejwwg wwxwwxw ;RPTH FPTHA;HARDDISK:CONSULT:ClarisII:v3:qafirst:Expense Line Items.fp3 NAMEA Expense Line Items.fp3 RPTHA Expense Line Items.fp3 WSPCA C:\CONSULT\ClarisII\v3\qafirst\ 7RPTH FPTHA7HARDDISK:CONSULT:ClarisII:v3:qafirst:Employee Names.fp3 NAMEA Employee Names.fp3 RPTHA Employee Names.fp3 WSPCA C:\CONSULT\ClarisII\v3\qafirst\ (LIST LISTA Auto Rental Tolls and Parking Air, Rail, Bus Taxi, Limousine Lodging Telephone Personal Meals Banquet Meals Business Meals Entertainment VDEFA( (LIST VDEFA( (LIST wwwwww ffffff UUUUUU DDDDDD wwffeffg@ veUEDDCC vUTDD44 vUDDC32 #""# weUDD3 veTDC2233#3#2 wUDDC3##" vUTD3#22 vUDDC fUD42233##3#"! vTDCC##" eUDC3223## fTD4C3##23#"" uTDC3323#2""! 22"2" ##2"! fTDD33#22"" vUDC32"2"" WUTC22 eTD3#"" GDC32"!! eD3#"! T32"" wwwwww ffffff UUUUUU DDDDDD #4EWp "4EVx #3EVg "4DUg "#4DVg 24EVgy "34EVw ##4Efw ""3DUgw ""33DUfw ""34DVgx ""#34EVgx "#33DEfw " 234DUfw 2""2334DEVgx 3 4DEUfwx 3 DDUVgw D EUUfwx UDDEUUfgw U Vfgwx eUVfgww "%UR UD33D AD@D@ AD@D@ B"#B@ B"#B"$ 4"2$B"#B"#C 2$""#B"#C0 4"2#B"#C0 2$B"D0#C0 4""#C0 44444 CCCCC 44444 CCCCC $42" bRBBP0 office@ VDEFA @@BA@ JJJJ !BBBB "99BB #9999 $9911 %1111 &))))C '!!!! *00**- *00-00 00*0) 00*&0# ## !0*!%00+#!*0##-0'"0*#%00.! UUUUU (*)(%,3& )%+@6) ",30,)% #*>A6332+$"! 25,878 #&$690*" !)0,++)( "%/66435/'# +3;4*= !#,@9,)+,(""(-/,,*,1! !$&(265389,#!$$ '275? $*23/$ $),-..)'' !$&)(-5439@1!!&*-3/)!!%6B) )220(!$*.,,.' !$&*,*023:?B+*.,/3254.' "++,3/(.584.," !#&+/-./3:9@G@60/16883)! $++//'(9CD>4.$$ $%)*-//2693,.075-&)3792,$ ")-1347<>@G71(! **)&'*.0350+%(=A2'%)579<94( +/11! !%'),342)1?=0)" .1,$',-01)*).AG6-/048:<H /2583$%+66/% %)++*),+&%06,%$# !/40')-/31$$,@HFC<6887:==@B7%! 6A235,% +,/13.%#"(16+ !#$(04-$&+,+$ %2>D6,59:989889=0 ,.22<=33* .22671# !!&/42& *1$&+,/3779733, $$PQ /004B6* !$$ $))'/3) %&$&.7;4 )2$)*3-)466/%$ !),02+' %$5)%*+%$! (+'0:==4 $+,,1643"%)" !)/1)*+ +7=-%%&$! !3)3=. %&*/3113 !$$PQ ',4-%)/) ,6/%$$" +(!<- %),0354- .13-&,-* 14'$$! %))&%$! '3*$$" !&$%3 &%"%& 9836' )&#%%! $*)++" .-/:% !"&)()15, )" /.-+)!L //6B& #'*,.42$ $/,-*% IF1A1 "%.2/-*#! $/.,*($!#$"%PQ #57-*'$#"$&' ..//.-,)'(.212PQ ",,)&%'.;<6/+',,)%! '//,+//*)+.4:=>PQ $(&(),5?@:2/,,''*$ -!,,%.0%)./7 #43((+9CA=3+N &*)2!$96;;48@??PQ )/01%$ #3/').:@<3)$&)! /)4$%)8=A@?><@PQ !.0/.+//./1//* *.').3784/% ,,#%()25:<99=PQ %10// 0 /+134,.25653." )++-! # %0,*,384'%PQ 42//11/&(/563135650( (./36$ !"23.,27- 6:=<)&931-13-!$.69433563+ ,/258 #$,96-37)$!P 38;?B>;63/.22.-068934673( ,638<6$ *),/6."')==138*$)PQ 35:=@B>953-/1.-368<:8995& %668:9( )$'*.:&$*==8/, -19=@CA>:83+2.,0157: !""/88$ !)*# 6/0%Q &' !$*38,.<;60" +07=@CD=6>@.*)&(*-03;@@<- 6.3/% #/23989=2,*% /039>B@ "9E7,)+/3667:?CE/!" $$%199207/ 9K8@) 3933" !0042381%$(.-)56PQ 556:=@@ 5C958=BGGA96;='"+- !!%.R 94.6BDCFM='(204967& //2346% $59232$PQ :9<@?@C% 6D;;CJLONG952 (9304=FCDDE>% $,585' !.//11'$/;81$ 9:CE><D3,5G@@HF>IF94) $#%+*159C=:>FG) *31*# $/51# 89C=.!:9=C<9AFG CA7&( /%3%!'+5A<6=C>$ -672.3<<961.%! ,,%=<9/69/02. "773//33/,+) /1$'9<3)" 069850(*)'% %/+$ !&##34 %0<PQ %"$:C9.*$ !+6@PQ "$$6CD>>5 !##() ".;CPQ %'0>GFA:378+&&%$$,& ,:CPQ $(,0V 27CGG@6681//,)%$/ '7CPQ !%*/1,/44CC;6547@=2*!%.$ %;CPQ '$)=3 #%)*())3DLHB ?MB9/% ! "'6?6$ *;=PQ $%&,9D6 !$%#"&)-:FIJHFGFBN@91)%"#(,/./:/#$-46PQ !)/38;@( "$$!"+29?DGIJKMLEIC83)'&-7:73)%$!!,5:PQ +/0,$%&%%,26:5) "$%&(/7;<=BGIJIGMG=953'%(1<<63/! $*.8PQ 6=@?<3),3:8$ !&((),3=;::=EHIC:<F3)'""#&+/,', #&(0PQ FC8:CF@7/08<( "'()*,169?:6=C=2..3'" "%&)PQ HD99=A@9534/ !26(%5, ! !),''*-16<@=430/,+/)! ??979>@@:-! !$+%-*),/37<@:2/-*)+*" 4?=95;@@9& *#%.,/136884/,)'),,%)+(%$$ />C:13?@9)$ !!89+ !)$%*-/13321/,Z *3*)-/0/+&$$! 6A:0,8B=1+)/68.%/(,9=2% ")$"%)-02331/31)/().241+%##! *79/)/:<651/33)2<8.6=9. !$%,56643/75,'&).340+&#!$$%#! .5.)/46682%#$$-973:=<7 !$'+4:964063+( ,33/+(&'),*)'# "%%.2379:1&"%(&.36@?@D5 !$%')/8:86>=2)&!!-231 34772+* &46339C@4+,3/)/:<D/8J=' "%'))+336@3(/)%#%,34569<=?CE5,)! #'21\ .7@C>9;99<9@CAE05J?,%$(.33/+,/26/)(,& #,0258<?ADGE2 "'(# "%),,/6983$ &4<9+4DD>?J>/*-6;<6,,/25.))3,' ",.0369;=AGE. !%%(,.040' 2A?EA4*+/683*.493/($!/-, 0246689:AC7% $%##(.23& :96,#"%)*(%(364,%"!!"560&)/<9;989;>3$ "03., PQ UUUUUU wwwwww UUUUUU wwwwww Expense Type ListB Project ListC Employee List FMRLA FMRLA Expense Line ItemsB Employee Names VDEFA( Open Expense Line Items File Open Employee Names File Information A List View Employee Expense Report Description This expense-tracking database file is a standard business form for reporting reimbursable business expenses. How to use this solution Your employees can enter information directly into the database. Or, they can create a new, blank record, print it, and complete the form by hand. The Report layout has an area for required signatures. How to customize this solution Enter your company's per mile reimbursement rate. To do this, choose Define Fields from the File menu, and doubBOle-click the Rate per Mile field. Then, change the value in the Data text box. officeD productE seminarF shippingF suppliesD systemF withE workE marketing consultants materials launch HP DeskJet 540 Printer Pro 2.0 - 2.1F! Pro 3.0